﻿CREATE TABLE [dbo].[HistoryDetails]
(
	Id int IDENTITY(1,1) NOT NULL, 
	HistoryId INT NOT NULL,
	CategoryId SMALLINT NULL,
	Category VARCHAR(200) NULL, --2
	Universe VARCHAR(200) NULL, --3
	[Role] VARCHAR(200) NULL, --4
	--Average
	AverageVolume BIGINT NULL, --5
	AverageSales MONEY NULL, --6
	AverageGIM MONEY NULL, --7
	AverageGIMP MONEY NULL, --8
	AverageDelistedVolume BIGINT NULL, --9
	AverageDelistedSales MONEY NULL, --10
	AverageDelistedGIM MONEY NULL, --11
	--Same Store Current Year
	SS_VolumeCY BIGINT NULL, --15
	SS_SalesCY MONEY NULL, --16
	SS_GIMCY MONEY NULL, --17
	SS_PIDiffCY MONEY NULL, --18
	SS_ChargeOffCY MONEY NULL, --19
	SS_RebatesCY MONEY NULL, --20
	SS_InventoryCY MONEY NULL, --27
	--Same Store Prior Year
	SS_VolumePY BIGINT NULL, --28
	SS_SalesPY MONEY NULL, --29
	SS_GIMPY MONEY NULL, --30
	SS_PIDiffPY MONEY NULL, --31
	SS_ChargeOffPY MONEY NULL, --32
	SS_RebatesPY MONEY NULL, --33
	SS_InventoryPY MONEY NULL, --40
	--Spaces
	Gondola MONEY NULL, --56
	TransactionArea MONEY NULL, --57
	GrabAndGo MONEY NULL, --58
	WIC MONEY NULL, --59
	OpenCooler MONEY NULL, --60
	Freezer MONEY NULL, --61
	Forecourt MONEY NULL, --62
	OtherExhibition MONEY NULL, --63
	--SKUs
	SKUsWithSales INT NULL, --72
	NewSKUs INT NULL, --73
	SKUsInSalesFiles INT NULL, --75
	DelistProposal INT NULL, --76
	--Pareto
	Sales10 INT NULL, --78
	Sales20 INT NULL, --79
	Sales30 INT NULL, --80
	Sales40 INT NULL, --81
	Sales50 INT NULL, --82
	Sales60 INT NULL, --83
	Sales70 INT NULL, --84
	Sales80 INT NULL, --85
	Sales90 INT NULL, --86
	Sales100 INT NULL, --87
	Bottom5 INT NULL, --88
	HurdleRate INT NULL, --89

	ActiveCategories [int] NULL, --91
	CategoriesWithInvAnalysis [int] NULL, --92
	Country [varchar](50) NOT NULL, --93
	[Range] [varchar](200) NOT NULL --94
)
